package cn.wolfcode.mapper;

import cn.wolfcode.domain.Dept;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface DeptMapper {

    @Select("""
          select id, name, create_time, update_time from dept
""")
    List<Dept> list();

    @Delete("""
          delete from dept where id = #{id}
""")
    void delete(long id);


    @Insert("""
          insert into dept (name, create_time, update_time)
          values (#{name}, now(), now())
""")
    void insert(Dept dept);

    @Select("""
          select id, name, create_time, update_time from dept where id = #{id}
""")
    Dept findById(long id);

    @Update("""
          update dept set name = #{name}, update_time = now() where id = #{id}
""")
    void update(Dept dept);
}
